<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
	<HEAD>
		<LINK href="../../../../Styles.css" type="text/css" rel="stylesheet"></HEAD>
	<BODY>
		<blockquote dir="ltr">
            <p>
                <br />
                Several series are <i>aligned</i> if they have the same number of data points 
                and the X values of all corresponding data points have identical values.
                <br />
                Series alignment enables you to make comparisons between series with values that 
                have the same X-axis range. This is useful when reading charts with multiple 
                data sets.
            </p>
            <p>
                The following example shows two series that are not aligned.</p>
        </blockquote>
        <p>
            <table id="Table2" cellpadding="1" cellspacing="1">
                <tr>
                    <td width="323">
                        <p align="center">
                            <img src="AlignSeries2-a.PNG" /></p>
                    </td>
                    <td>
                        <blockquote dir="ltr">
                            <blockquote dir="ltr">
                                <p align="center" class="Small">
                                    <table id="Table4" align="center" border="1" cellpadding="1" cellspacing="1">
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    <u><strong>Day</strong></u></p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    <u><strong>Product&nbsp;A</strong></u></p>
                                            </td>
                                            <td>
                                                <u><strong>Product&nbsp;B</strong></u></td>
                                        </tr>
                                        <tr>
                                            <td>
                                                May 27
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $41</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    ($0)</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 28</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $48</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $81</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 28</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $52</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    &nbsp;</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 29</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $73</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $29</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 30</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $26</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    ($0)</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 31</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $58</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $23</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 31</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $68</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    &nbsp;</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    Jun 1</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $72</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $23</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    Jun 2</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $23</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    ($0)</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    Jun 2</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $17</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    &nbsp;</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    Jun 3</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    ($0)</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $69</p>
                                            </td>
                                        </tr>
                                    </table>
                                </p>
                            </blockquote>
                        </blockquote>
                    </td>
                </tr>
            </table>
        </p>
        <blockquote dir="ltr">
            <p>
                In the example above, some days do not have any data point and other days have 
                more than one data points. Furthermore, the data points do not line up with the 
                grid lines because they data points of the same date have different time values.
            </p>
            <p>
                By aligning the two series in the example above, you can get a chart that makes 
                more sense. The figure below displays data that is grouped by day&nbsp;and includes 
                empty points:</p>
        </blockquote>
        <p>
            <table id="Table6" cellpadding="1" cellspacing="1">
                <tr>
                    <td width="323">
                        <p align="center">
                            <img src="AlignSeries4-b.PNG" />
                        </p>
                    </td>
                    <td>
                        <blockquote dir="ltr">
                            <blockquote dir="ltr">
                                <p align="left">
                                    <table id="Table7" border="1" cellpadding="1" cellspacing="1">
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    <strong><u>Day</u></strong></p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    <strong><u>Product A</u></strong></p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    <strong><u>Product B</u></strong></p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 27
                                                </p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $41</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    (empty)</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 28</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    <font color="#ff0000">$50</font></p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $81</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 29</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $73</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $29</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 30</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $26</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    (empty)</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    May 31</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    <font color="#ff0000">$63</font></p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $23</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    Jun 1</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $72</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    (empty)</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    Jun 2</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    <font color="#ff0000">$20</font></p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $23</p>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <p align="center">
                                                    Jun 3</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    (empty)</p>
                                            </td>
                                            <td>
                                                <p align="center">
                                                    $69</p>
                                            </td>
                                        </tr>
                                    </table>
                                </p>
                            </blockquote>
                        </blockquote>
                    </td>
                </tr>
            </table>
        </p>
        <h3>
            When is Series Alignment Required?</h3>
        <blockquote>
            <p>
                The following operations <u>require</u> charts<em> </em>with multiple series to 
                be aligned otherwise an exception will be thrown:
            </p>
            <ul>
                <li>When drawing a stacked area, bar or column chart (including all 100% stacked 
                    charts). </li>
                <li>When sorting data in multiple series with one <strong>Sort</strong> method call.
                </li>
                <li>When filtering data in multiple series with one <strong>Filter</strong> method 
                    call. </li>
                <li>When copying, splitting or merging data from multiple series using one <strong>
                    CopySeriesValues</strong> method call. </li>
                <li>When displaying multiple series (in the same chart area) with indexed X values (<strong>IsXValueIndexed</strong> 
                    property set to TRUE). </li>
            </ul>
        </blockquote>
        <h3>
            How to Align Series
        </h3>
        <blockquote dir="ltr">
            <p>
                You can align two series grouping data, filtering data, and inserting empty data 
                points.
            </p>
            <h4>
                Grouping</h4>
            <p>
                Group series points in desired intervals, such as days, weeks, and months. 
                Multiple points are grouped into single points (see the figures below).</p>
        </blockquote>
        <p>
            <table id="Table1" cellpadding="1" cellspacing="1">
                <tr>
                    <td width="344">
                        <p align="center">
                            <img src="Grouping2-a.PNG" /><br />
                            <strong>Ungrouped</strong>
                        </p>
                    </td>
                    <td>
                        <p align="center">
                            <img src="Grouping2-b.PNG" /><br />
                            <strong>Grouped</strong>
                        </p>
                    </td>
                </tr>
            </table>
        </p>
        <blockquote dir="ltr">
            <h4>
                Inserting Empty Points</h4>
            <p>
                Empty points represent missing data and can be used to maintain the same number 
                of points in all series.
            </p>
            <p>
                The figure below demonstrates the use of empty points to align two series.</p>
        </blockquote>
        <p>
            <table id="Table3" cellpadding="1" cellspacing="1">
                <tr>
                    <td width="344">
                        <p align="center">
                            <img src="NoEmptyPoints2-a.PNG" /><br />
                            <strong>Data&nbsp;without Empty Points</strong>&nbsp;</p>
                    </td>
                    <td>
                        <p align="center">
                            <img src="NoEmptyPoints2-b.PNG" /><br />
                            <strong>Data with Empty Points</strong></p>
                    </td>
                </tr>
            </table>
        </p>
	</BODY>
</HTML>
